﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Areas/Forum/Views/Shared/ForumModerator.Master" Inherits="System.Web.Mvc.ViewPage" %>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <h4>Data Integrity</h4>
    
    <hr />
    Two items can indicate loss of integrity in the Post table in Sql Server:<br />&nbsp;&nbsp;&nbsp;&nbsp;
        1.&nbsp; Deleting a subject without deleting posts to that subject<br />&nbsp;&nbsp;&nbsp;&nbsp;
        2.&nbsp; A count of posts to a subject becoming incorrect for some reason
    <br /><br />
    Notes:&nbsp; Flagged subjects and posts (not yet approved by the Moderator) are still in the Post table, and are considered valid entries for integrity pursoses.
    <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                 It will be an apparent error to the user that the count of posts to a subject includes this flagged item, yet the item is not shown.
    <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                 Flagged subjects will not be shown, and their related posts will also still exist in the database, and not be shown.
    <br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                 When posts are found which are not assigned to a subject, they are not deleted.&nbsp;  This is because the Moderator may wish to retain these posts,
    <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                 and create an acceptable,&nbsp; appropriate Subject to which these posts can be assigned
    <br /><br />
    Clicking the following link should fix item 2 above, and advise the moderator of the condition of item 1
    <br /><br />
    <%: Html.ActionLink("Check Integrity", "CheckIntegrity", "Moderator") %> 
    <br /><br /><br /><br /> 

</asp:Content>
